"192.168.0.1:sipop"

PATOLOGIAS_AU

Descriptions

There is no desription for trigger PATOLOGIAS_AU

Definition

CREATE TRIGGER PATOLOGIAS_AU FOR PATOLOGIAS ACTIVE
AFTER DELETE POSITION 0
AS
declare variable HIJO INTEGER;
BEGIN
  /* Trigger body */

   SELECT COUNT (ID_PATOLOGIAS) FROM PATOLOGIAS
   WHERE
           ID_PADRE_PATOLOGIA = OLD.ID_PADRE_PATOLOGIA
   INTO:HIJO;
  UPDATE PATOLOGIAS SET HIJOS = :HIJO WHERE ID_PATOLOGIAS = OLD.ID_PADRE_PATOLOGIA;

END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.